package com.sl.au.repository;

import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.transaction.annotation.Transactional;

import com.sl.au.entity.EXDEviewPayTotal;

/**
 * 市场部回款统计
 * @author yry
 * 2017-02-20
 */
@Transactional(readOnly = true)
public interface EXDEPayBackToArticleRepository extends JpaRepository<EXDEviewPayTotal, String>  {

	//查询某一年每个月的数据
	@Query("SELECT l FROM EXDEviewPayTotal as l where l.dPaidDate like ''+?1+'%' order by l.dPaidDate,l.superior")
	List<EXDEviewPayTotal> findAllTrance(String year);
}
